<!--
- Copyright (C) 2024 HiHope Open Source Organization.
- Licensed under the Apache License, Version 2.0 (the "License");
- you may not use this file except in compliance with the License.
- You may obtain a copy of the License at
-
-   http://www.apache.org/licenses/LICENSE-2.0
-
- Unless required by applicable law or agreed to in writing, software
- distributed under the License is distributed on an "AS IS" BASIS,
- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- See the License for the specific language governing permissions and
- limitations under the License.
-->

<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>test</title>
    <script type="text/javascript">

        let db = openDatabase('mydb','1.0','Test DB',2 * 1024 * 1024);
        let msg;

        db.transaction(function(tx){
          tx.executeSql('INSERT INTO LOGS (id,log) VALUES(1,'test1')');
          tx.executeSql('INSERT INTO LOGS (id,log) VALUES(2,'test2')');
          msg = '<p>数据表已创建,且插入了两条数据。</p>';

          document.querySelector('#status').innerHTML = msg;
        });

        db.transaction(function(tx){
          tx.executeSql('SELECT * FROM LOGS', [], function (tx, results) {
            let len = results.rows.length;
            let i;
            msg = '<p>查询记录条数：' + len + '</p>';

            document.querySelector('#status').innerHTML += msg;

                for(i = 0; i < len; i++){
                  msg = '<p><b>' + results.rows.item(i).log + '</b></p>';

            document.querySelector('#status').innerHTML += msg;
            }
          }, null);
        });

    </script>
</head>
<body>
<div id='status' name='status'>状态信息</div>
</body>
</html>